﻿CREATE TABLE [dbo].[NavigationItem] (
    [NavigationItemId]               UNIQUEIDENTIFIER NULL,
    [ApplicationUINodeId]            UNIQUEIDENTIFIER NULL,
    [NavigationItemTypeId]           UNIQUEIDENTIFIER NULL,
    [NavigationItemText]             VARCHAR (50)     NULL,
    [NavigationTargetId]             UNIQUEIDENTIFIER NULL,
    [NavigationTargetTypeId]         UNIQUEIDENTIFIER NULL,
    [NavigationTargetLocationId]     UNIQUEIDENTIFIER NULL,
    [NavigationTargetLocationTypeId] UNIQUEIDENTIFIER NULL,
    [QueryString]                    TEXT             NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'Description', @value = N'Specifies the UI Item that will be loaded', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NavigationItem', @level2type = N'COLUMN', @level2name = N'NavigationTargetId';


GO
EXECUTE sp_addextendedproperty @name = N'Description', @value = N'Specifies where the UI Target will be loaded. I.E. a frame, Content Page, Multiview content, Control Template, Parent Panel, etc.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'NavigationItem', @level2type = N'COLUMN', @level2name = N'NavigationTargetLocationId';

